Implementing Campaign Manager - External Integrations


Running The Scripts Using Pan

Procedure

  1. Use Spoon to configure the step. Save the script, and make a note of the location.
  2. Open a command prompt or save the following steps into a *.bat file. Using a *.bat file allows for repeated execution from a scheduler.
  3. Navigate to the Kettle directory.
    cd C:\Kettle\data-integration\
  4. Run Pan. The full path is required to run pan.bat if running from a *.bat file.
    C:\Kettle\data-integration\Pan.bat
  5. Add the required parameters to the process.
    1. The file value specifies which Kettle job to run.
      -file:"Path\To\NameOfTransformScript.ktr"
    2. The level value specifies which level of Kettle logging to record.
      -level:"Detailed"
    3. The value of any named parameters set in the transform can optionally be passed using the -param switch.
      - param:access_token=xxxxxxxx
  6. It is recommended to send the Kettle log to a file rather than let it go to the command line. Use > to send the output to the specified file. Use >> to append the output to the specified file.
    > C:\Testing\KitchenRun.log
  Online & Instructor-Led Courses | Training Videos | Webinar Recordings
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice